Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 57851 |
| Missing cells | 4853 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 8.4 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Text | 2 |
|---|---|
| DateTime | 1 |
| Numeric | 10 |
| Categorical | 5 |
| Unsupported | 1 |
Category is highly overall correlated with Subcategory | High correlation |
Color is highly overall correlated with Subcategory | High correlation |
Continent is highly overall correlated with Country | High correlation |
Cost is highly overall correlated with Profit_Margin and 2 other fields | High correlation |
Country is highly overall correlated with Continent and 2 other fields | High correlation |
EmployeeKey is highly overall correlated with Country and 1 other fields | High correlation |
ProductKey is highly overall correlated with Subcategory | High correlation |
Profit is highly overall correlated with Profit_Margin | High correlation |
Profit_Margin is highly overall correlated with Cost and 1 other fields | High correlation |
Sales is highly overall correlated with Cost and 1 other fields | High correlation |
SalesTerritoryKey is highly overall correlated with Country and 1 other fields | High correlation |
Subcategory is highly overall correlated with Category and 2 other fields | High correlation |
Unit Price is highly overall correlated with Cost and 1 other fields | High correlation |
Continent is highly imbalanced (52.3%) | Imbalance |
Color has 4853 (8.4%) missing values | Missing |
Profit_Margin is highly skewed (γ1 = -39.79601447) | Skewed |
trimestre is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-04-10 00:35:10.882269 |
|---|---|
| Analysis finished | 2024-04-10 00:35:58.241513 |
| Duration | 47.36 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
SalesOrderNumber
Text
| Distinct | 3616 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 404957 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 564 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | SO43897 |
|---|---|
| 2nd row | SO43897 |
| 3rd row | SO43897 |
| 4th row | SO43897 |
| 5th row | SO44544 |
| Value | Count | Frequency (%) |
| so51721 | 72 | 0.1% |
| so51739 | 72 | 0.1% |
| so51160 | 71 | 0.1% |
| so53465 | 71 | 0.1% |
| so47355 | 68 | 0.1% |
| so57046 | 67 | 0.1% |
| so51120 | 67 | 0.1% |
| so51090 | 66 | 0.1% |
| so55297 | 66 | 0.1% |
| so47395 | 66 | 0.1% |
| Other values (3606) | 57165 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 57851 | |
| O | 57851 | |
| 4 | 45461 | |
| 5 | 45205 | |
| 6 | 32266 | |
| 7 | 27168 | |
| 1 | 25806 | |
| 3 | 24595 | |
| 0 | 23661 | |
| 9 | 23228 | |
| Other values (2) | 41865 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 404957 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 57851 | |
| O | 57851 | |
| 4 | 45461 | |
| 5 | 45205 | |
| 6 | 32266 | |
| 7 | 27168 | |
| 1 | 25806 | |
| 3 | 24595 | |
| 0 | 23661 | |
| 9 | 23228 | |
| Other values (2) | 41865 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 404957 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 57851 | |
| O | 57851 | |
| 4 | 45461 | |
| 5 | 45205 | |
| 6 | 32266 | |
| 7 | 27168 | |
| 1 | 25806 | |
| 3 | 24595 | |
| 0 | 23661 | |
| 9 | 23228 | |
| Other values (2) | 41865 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 404957 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 57851 | |
| O | 57851 | |
| 4 | 45461 | |
| 5 | 45205 | |
| 6 | 32266 | |
| 7 | 27168 | |
| 1 | 25806 | |
| 3 | 24595 | |
| 0 | 23661 | |
| 9 | 23228 | |
| Other values (2) | 41865 |
OrderDate
Date
| Distinct | 990 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
| Minimum | 2017-07-01 00:00:00 |
|---|---|
| Maximum | 2020-05-31 00:00:00 |
ProductKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 408.6367 |
| Minimum | 212 |
|---|---|
| Maximum | 606 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 212 |
|---|---|
| 5-th percentile | 223 |
| Q1 | 326 |
| median | 401 |
| Q3 | 491 |
| 95-th percentile | 586 |
| Maximum | 606 |
| Range | 394 |
| Interquartile range (IQR) | 165 |
Descriptive statistics
| Standard deviation | 113.66564 |
|---|---|
| Coefficient of variation (CV) | 0.27815819 |
| Kurtosis | -1.058689 |
| Mean | 408.6367 |
| Median Absolute Deviation (MAD) | 82 |
| Skewness | -0.012319591 |
| Sum | 23640042 |
| Variance | 12919.879 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 471 | 466 | 0.8% |
| 491 | 447 | 0.8% |
| 224 | 442 | 0.8% |
| 458 | 437 | 0.8% |
| 233 | 436 | 0.8% |
| 456 | 418 | 0.7% |
| 483 | 418 | 0.7% |
| 225 | 417 | 0.7% |
| 234 | 410 | 0.7% |
| 477 | 402 | 0.7% |
| Other values (324) | 53558 |
| Value | Count | Frequency (%) |
| 212 | 200 | |
| 213 | 317 | |
| 214 | 306 | |
| 215 | 201 | |
| 216 | 340 | |
| 217 | 348 | |
| 218 | 188 | |
| 219 | 44 | 0.1% |
| 220 | 215 | |
| 221 | 372 |
| Value | Count | Frequency (%) |
| 606 | 286 | |
| 605 | 298 | |
| 604 | 98 | 0.2% |
| 603 | 188 | |
| 601 | 125 | |
| 600 | 95 | 0.2% |
| 599 | 161 | |
| 598 | 123 | |
| 597 | 138 | |
| 596 | 91 | 0.2% |
ResellerKey
Real number (ℝ)
| Distinct | 632 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 340.74298 |
| Minimum | 1 |
|---|---|
| Maximum | 701 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 166 |
| median | 327 |
| Q3 | 514 |
| 95-th percentile | 675 |
| Maximum | 701 |
| Range | 700 |
| Interquartile range (IQR) | 348 |
Descriptive statistics
| Standard deviation | 205.49391 |
|---|---|
| Coefficient of variation (CV) | 0.60307598 |
| Kurtosis | -1.2241433 |
| Mean | 340.74298 |
| Median Absolute Deviation (MAD) | 175 |
| Skewness | 0.084246705 |
| Sum | 19712322 |
| Variance | 42227.745 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 678 | 469 | 0.8% |
| 514 | 451 | 0.8% |
| 54 | 443 | 0.8% |
| 496 | 441 | 0.8% |
| 175 | 440 | 0.8% |
| 328 | 436 | 0.8% |
| 84 | 436 | 0.8% |
| 221 | 432 | 0.7% |
| 167 | 422 | 0.7% |
| 475 | 418 | 0.7% |
| Other values (622) | 53463 |
| Value | Count | Frequency (%) |
| 1 | 73 | 0.1% |
| 2 | 70 | 0.1% |
| 3 | 359 | |
| 4 | 235 | |
| 5 | 71 | 0.1% |
| 6 | 5 | < 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 31 | 0.1% |
| 9 | 30 | 0.1% |
| 10 | 217 |
| Value | Count | Frequency (%) |
| 701 | 11 | < 0.1% |
| 700 | 157 | |
| 699 | 1 | < 0.1% |
| 698 | 21 | < 0.1% |
| 697 | 298 | |
| 696 | 2 | < 0.1% |
| 695 | 60 | 0.1% |
| 694 | 8 | < 0.1% |
| 693 | 89 | 0.2% |
| 692 | 82 | 0.1% |
EmployeeKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 286.13173 |
| Minimum | 272 |
|---|---|
| Maximum | 296 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 272 |
|---|---|
| 5-th percentile | 281 |
| Q1 | 283 |
| median | 285 |
| Q3 | 290 |
| 95-th percentile | 294 |
| Maximum | 296 |
| Range | 24 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.5218323 |
|---|---|
| Coefficient of variation (CV) | 0.015803323 |
| Kurtosis | -0.073423976 |
| Mean | 286.13173 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.12307418 |
| Sum | 16553007 |
| Variance | 20.446967 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 283 | 7529 | |
| 282 | 6843 | |
| 281 | 6734 | |
| 291 | 6374 | |
| 285 | 5250 | |
| 287 | 4357 | |
| 288 | 4159 | |
| 292 | 3311 | |
| 284 | 3138 | 5.4% |
| 289 | 2146 | 3.7% |
| Other values (7) | 8010 |
| Value | Count | Frequency (%) |
| 272 | 747 | 1.3% |
| 281 | 6734 | |
| 282 | 6843 | |
| 283 | 7529 | |
| 284 | 3138 | |
| 285 | 5250 | |
| 286 | 1945 | 3.4% |
| 287 | 4357 | |
| 288 | 4159 | |
| 289 | 2146 | 3.7% |
| Value | Count | Frequency (%) |
| 296 | 1183 | 2.0% |
| 295 | 1561 | 2.7% |
| 294 | 240 | 0.4% |
| 293 | 1750 | 3.0% |
| 292 | 3311 | |
| 291 | 6374 | |
| 290 | 584 | 1.0% |
| 289 | 2146 | 3.7% |
| 288 | 4159 | |
| 287 | 4357 |
SalesTerritoryKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5544243 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.4122469 |
|---|---|
| Coefficient of variation (CV) | 0.52964914 |
| Kurtosis | -0.30710651 |
| Mean | 4.5544243 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.43104057 |
| Sum | 263478 |
| Variance | 5.8189351 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 12826 | |
| 6 | 10934 | |
| 1 | 7446 | |
| 5 | 5742 | |
| 2 | 5610 | |
| 3 | 5527 | |
| 7 | 3422 | 5.9% |
| 10 | 3242 | 5.6% |
| 8 | 1679 | 2.9% |
| 9 | 1423 | 2.5% |
| Value | Count | Frequency (%) |
| 1 | 7446 | |
| 2 | 5610 | |
| 3 | 5527 | |
| 4 | 12826 | |
| 5 | 5742 | |
| 6 | 10934 | |
| 7 | 3422 | 5.9% |
| 8 | 1679 | 2.9% |
| 9 | 1423 | 2.5% |
| 10 | 3242 | 5.6% |
| Value | Count | Frequency (%) |
| 10 | 3242 | 5.6% |
| 9 | 1423 | 2.5% |
| 8 | 1679 | 2.9% |
| 7 | 3422 | 5.9% |
| 6 | 10934 | |
| 5 | 5742 | |
| 4 | 12826 | |
| 3 | 5527 | |
| 2 | 5610 | |
| 1 | 7446 |
Quantity
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5282709 |
| Minimum | 1 |
|---|---|
| Maximum | 44 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 9 |
| Maximum | 44 |
| Range | 43 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.0357664 |
|---|---|
| Coefficient of variation (CV) | 0.86041193 |
| Kurtosis | 14.057696 |
| Mean | 3.5282709 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.8354561 |
| Sum | 204114 |
| Variance | 9.2158775 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 13713 | |
| 2 | 13476 | |
| 3 | 9593 | |
| 4 | 7150 | |
| 5 | 4202 | 7.3% |
| 6 | 3134 | 5.4% |
| 7 | 1649 | 2.9% |
| 8 | 1455 | 2.5% |
| 9 | 798 | 1.4% |
| 10 | 727 | 1.3% |
| Other values (31) | 1954 | 3.4% |
| Value | Count | Frequency (%) |
| 1 | 13713 | |
| 2 | 13476 | |
| 3 | 9593 | |
| 4 | 7150 | |
| 5 | 4202 | 7.3% |
| 6 | 3134 | 5.4% |
| 7 | 1649 | 2.9% |
| 8 | 1455 | 2.5% |
| 9 | 798 | 1.4% |
| 10 | 727 | 1.3% |
| Value | Count | Frequency (%) |
| 44 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 39 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 36 | 2 | < 0.1% |
| 35 | 2 | < 0.1% |
| 34 | 3 | |
| 33 | 6 | |
| 32 | 7 |
Unit Price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 230 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 446.38851 |
| Minimum | 1.33 |
|---|---|
| Maximum | 2146.96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 1.33 |
|---|---|
| 5-th percentile | 11.665 |
| Q1 | 34.93 |
| median | 214.24 |
| Q3 | 672.29 |
| 95-th percentile | 1466.01 |
| Maximum | 2146.96 |
| Range | 2145.63 |
| Interquartile range (IQR) | 637.36 |
Descriptive statistics
| Standard deviation | 521.88016 |
|---|---|
| Coefficient of variation (CV) | 1.1691165 |
| Kurtosis | 1.304735 |
| Mean | 446.38851 |
| Median Absolute Deviation (MAD) | 197.97 |
| Skewness | 1.4130702 |
| Sum | 25824022 |
| Variance | 272358.91 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 469.79 | 2969 | 5.1% |
| 419.46 | 2198 | 3.8% |
| 28.84 | 1593 | 2.8% |
| 20.19 | 1493 | 2.6% |
| 323.99 | 1463 | 2.5% |
| 1466.01 | 1353 | 2.3% |
| 1430.44 | 1251 | 2.2% |
| 202.33 | 1203 | 2.1% |
| 445.41 | 1165 | 2.0% |
| 32.39 | 1095 | 1.9% |
| Other values (220) | 42068 |
| Value | Count | Frequency (%) |
| 1.33 | 1 | < 0.1% |
| 1.37 | 150 | |
| 2.5 | 1 | < 0.1% |
| 2.74 | 19 | < 0.1% |
| 2.89 | 31 | 0.1% |
| 2.99 | 351 | |
| 3.98 | 1 | < 0.1% |
| 4.32 | 1 | < 0.1% |
| 4.37 | 14 | < 0.1% |
| 4.5 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2146.96 | 539 | 0.9% |
| 2039.99 | 643 | |
| 2024.99 | 661 | |
| 1971.99 | 3 | < 0.1% |
| 1957.49 | 6 | < 0.1% |
| 1466.01 | 1353 | |
| 1430.44 | 1251 | |
| 1417.14 | 4 | < 0.1% |
| 1391.99 | 549 | |
| 1382.76 | 22 | < 0.1% |
Sales
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1406 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1336.9383 |
| Minimum | 1.37 |
|---|---|
| Maximum | 30993.04 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 1.37 |
|---|---|
| 5-th percentile | 25.95 |
| Q1 | 127.8 |
| median | 469.79 |
| Q3 | 1488.54 |
| 95-th percentile | 5567.96 |
| Maximum | 30993.04 |
| Range | 30991.67 |
| Interquartile range (IQR) | 1360.74 |
Descriptive statistics
| Standard deviation | 2150.4083 |
|---|---|
| Coefficient of variation (CV) | 1.6084574 |
| Kurtosis | 16.847004 |
| Mean | 1336.9383 |
| Median Absolute Deviation (MAD) | 412.11 |
| Skewness | 3.4113958 |
| Sum | 77343217 |
| Variance | 4624255.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 419.46 | 789 | 1.4% |
| 939.58 | 665 | 1.1% |
| 838.92 | 657 | 1.1% |
| 469.79 | 639 | 1.1% |
| 1409.37 | 596 | 1.0% |
| 323.99 | 462 | 0.8% |
| 445.41 | 431 | 0.7% |
| 1430.44 | 411 | 0.7% |
| 183.94 | 401 | 0.7% |
| 647.98 | 374 | 0.6% |
| Other values (1396) | 52426 |
| Value | Count | Frequency (%) |
| 1.37 | 25 | < 0.1% |
| 2.74 | 25 | < 0.1% |
| 2.99 | 29 | 0.1% |
| 4.11 | 22 | < 0.1% |
| 4.77 | 35 | 0.1% |
| 5.19 | 94 | |
| 5.39 | 79 | |
| 5.48 | 19 | < 0.1% |
| 5.7 | 21 | < 0.1% |
| 5.98 | 44 |
| Value | Count | Frequency (%) |
| 30993.04 | 1 | < 0.1% |
| 27607.86 | 1 | < 0.1% |
| 27536.04 | 1 | < 0.1% |
| 25515 | 1 | < 0.1% |
| 25447.37 | 1 | < 0.1% |
| 24913.56 | 1 | < 0.1% |
| 23663.88 | 2 | |
| 23602.32 | 2 | |
| 23489.88 | 3 | |
| 22291.08 | 1 | < 0.1% |
Cost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1430 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1323.2109 |
| Minimum | 0.86 |
|---|---|
| Maximum | 38530.39 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | 0.86 |
|---|---|
| 5-th percentile | 19.43 |
| Q1 | 97.15 |
| median | 461.44 |
| Q3 | 1510.3 |
| 95-th percentile | 5537.34 |
| Maximum | 38530.39 |
| Range | 38529.53 |
| Interquartile range (IQR) | 1413.15 |
Descriptive statistics
| Standard deviation | 2169.7876 |
|---|---|
| Coefficient of variation (CV) | 1.6397897 |
| Kurtosis | 19.768571 |
| Mean | 1323.2109 |
| Median Absolute Deviation (MAD) | 422.18 |
| Skewness | 3.5560074 |
| Sum | 76549076 |
| Variance | 4707978.4 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 413.15 | 789 | 1.4% |
| 973.41 | 675 | 1.2% |
| 826.29 | 655 | 1.1% |
| 486.71 | 650 | 1.1% |
| 1460.12 | 610 | 1.1% |
| 461.44 | 597 | 1.0% |
| 1481.94 | 481 | 0.8% |
| 922.89 | 433 | 0.7% |
| 2963.88 | 404 | 0.7% |
| 1946.83 | 378 | 0.7% |
| Other values (1420) | 52179 |
| Value | Count | Frequency (%) |
| 0.86 | 25 | |
| 1.71 | 25 | |
| 1.87 | 29 | |
| 2.57 | 22 | |
| 2.97 | 35 | |
| 3.36 | 51 | |
| 3.4 | 21 | |
| 3.43 | 19 | < 0.1% |
| 3.73 | 44 | |
| 4.28 | 17 | < 0.1% |
| Value | Count | Frequency (%) |
| 38530.39 | 1 | < 0.1% |
| 32475.3 | 1 | < 0.1% |
| 31120.7 | 2 | |
| 28156.82 | 1 | < 0.1% |
| 26770.16 | 1 | < 0.1% |
| 26674.88 | 2 | |
| 25192.94 | 1 | < 0.1% |
| 24675.23 | 1 | < 0.1% |
| 23815.22 | 1 | < 0.1% |
| 23711.01 | 4 |
Country
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
| United States | |
|---|---|
| Canada | |
| France | 3422 |
| United Kingdom | 3242 |
| Germany | 1679 |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 11.04643 |
| Min length | 6 |
Characters and Unicode
| Total characters | 639047 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 37151 | |
| Canada | 10934 | 18.9% |
| France | 3422 | 5.9% |
| United Kingdom | 3242 | 5.6% |
| Germany | 1679 | 2.9% |
| Australia | 1423 | 2.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 40393 | |
| states | 37151 | |
| canada | 10934 | 11.1% |
| france | 3422 | 3.5% |
| kingdom | 3242 | 3.3% |
| germany | 1679 | 1.7% |
| australia | 1423 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 116118 | |
| e | 82645 | |
| a | 77900 | |
| n | 59670 | |
| d | 54569 | |
| i | 45058 | 7.1% |
| U | 40393 | 6.3% |
| 40393 | 6.3% | |
| s | 38574 | 6.0% |
| S | 37151 | 5.8% |
| Other values (13) | 46576 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 639047 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 116118 | |
| e | 82645 | |
| a | 77900 | |
| n | 59670 | |
| d | 54569 | |
| i | 45058 | 7.1% |
| U | 40393 | 6.3% |
| 40393 | 6.3% | |
| s | 38574 | 6.0% |
| S | 37151 | 5.8% |
| Other values (13) | 46576 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 639047 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 116118 | |
| e | 82645 | |
| a | 77900 | |
| n | 59670 | |
| d | 54569 | |
| i | 45058 | 7.1% |
| U | 40393 | 6.3% |
| 40393 | 6.3% | |
| s | 38574 | 6.0% |
| S | 37151 | 5.8% |
| Other values (13) | 46576 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 639047 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 116118 | |
| e | 82645 | |
| a | 77900 | |
| n | 59670 | |
| d | 54569 | |
| i | 45058 | 7.1% |
| U | 40393 | 6.3% |
| 40393 | 6.3% | |
| s | 38574 | 6.0% |
| S | 37151 | 5.8% |
| Other values (13) | 46576 |
Continent
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
| North America | |
|---|---|
| Europe | |
| Pacific | 1423 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 11.842907 |
| Min length | 6 |
Characters and Unicode
| Total characters | 685124 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North America |
|---|---|
| 2nd row | North America |
| 3rd row | North America |
| 4th row | North America |
| 5th row | North America |
Common Values
| Value | Count | Frequency (%) |
| North America | 48085 | |
| Europe | 8343 | 14.4% |
| Pacific | 1423 | 2.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| north | 48085 | |
| america | 48085 | |
| europe | 8343 | 7.9% |
| pacific | 1423 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 104513 | |
| e | 56428 | |
| o | 56428 | |
| c | 50931 | |
| i | 50931 | |
| a | 49508 | 7.2% |
| m | 48085 | 7.0% |
| N | 48085 | 7.0% |
| A | 48085 | 7.0% |
| 48085 | 7.0% | |
| Other values (7) | 124045 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 685124 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 104513 | |
| e | 56428 | |
| o | 56428 | |
| c | 50931 | |
| i | 50931 | |
| a | 49508 | 7.2% |
| m | 48085 | 7.0% |
| N | 48085 | 7.0% |
| A | 48085 | 7.0% |
| 48085 | 7.0% | |
| Other values (7) | 124045 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 685124 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 104513 | |
| e | 56428 | |
| o | 56428 | |
| c | 50931 | |
| i | 50931 | |
| a | 49508 | 7.2% |
| m | 48085 | 7.0% |
| N | 48085 | 7.0% |
| A | 48085 | 7.0% |
| 48085 | 7.0% | |
| Other values (7) | 124045 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 685124 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 104513 | |
| e | 56428 | |
| o | 56428 | |
| c | 50931 | |
| i | 50931 | |
| a | 49508 | 7.2% |
| m | 48085 | 7.0% |
| N | 48085 | 7.0% |
| A | 48085 | 7.0% |
| 48085 | 7.0% | |
| Other values (7) | 124045 |
Product
Text
| Distinct | 250 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 21.218492 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1227511 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Long-Sleeve Logo Jersey, XL |
|---|---|
| 2nd row | Mountain-100 Black, 48 |
| 3rd row | Mountain-100 Black, 38 |
| 4th row | Long-Sleeve Logo Jersey, L |
| 5th row | HL Mountain Frame - Silver, 48 |
| Value | Count | Frequency (%) |
| black | 12760 | 6.1% |
| 11601 | 5.5% | |
| mountain | 8466 | 4.0% |
| frame | 8331 | 4.0% |
| red | 8037 | 3.8% |
| road | 6574 | 3.1% |
| ll | 6361 | 3.0% |
| yellow | 6304 | 3.0% |
| hl | 5868 | 2.8% |
| silver | 5510 | 2.6% |
| Other values (90) | 130713 |
Most occurring characters
| Value | Count | Frequency (%) |
| 152674 | 12.4% | |
| e | 79832 | 6.5% |
| a | 73700 | 6.0% |
| o | 72198 | 5.9% |
| l | 55267 | 4.5% |
| 0 | 50257 | 4.1% |
| - | 49776 | 4.1% |
| n | 49247 | 4.0% |
| , | 46989 | 3.8% |
| r | 40606 | 3.3% |
| Other values (47) | 556965 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1227511 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 152674 | 12.4% | |
| e | 79832 | 6.5% |
| a | 73700 | 6.0% |
| o | 72198 | 5.9% |
| l | 55267 | 4.5% |
| 0 | 50257 | 4.1% |
| - | 49776 | 4.1% |
| n | 49247 | 4.0% |
| , | 46989 | 3.8% |
| r | 40606 | 3.3% |
| Other values (47) | 556965 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1227511 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 152674 | 12.4% | |
| e | 79832 | 6.5% |
| a | 73700 | 6.0% |
| o | 72198 | 5.9% |
| l | 55267 | 4.5% |
| 0 | 50257 | 4.1% |
| - | 49776 | 4.1% |
| n | 49247 | 4.0% |
| , | 46989 | 3.8% |
| r | 40606 | 3.3% |
| Other values (47) | 556965 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1227511 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 152674 | 12.4% | |
| e | 79832 | 6.5% |
| a | 73700 | 6.0% |
| o | 72198 | 5.9% |
| l | 55267 | 4.5% |
| 0 | 50257 | 4.1% |
| - | 49776 | 4.1% |
| n | 49247 | 4.0% |
| , | 46989 | 3.8% |
| r | 40606 | 3.3% |
| Other values (47) | 556965 |
Color
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4853 |
| Missing (%) | 8.4% |
| Memory size | 452.1 KiB |
| Black | |
|---|---|
| Red | |
| Yellow | |
| Silver | |
| Blue | |
| Other values (3) |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 5.0593607 |
| Min length | 3 |
Characters and Unicode
| Total characters | 268136 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Multi |
|---|---|
| 2nd row | Black |
| 3rd row | Black |
| 4th row | Multi |
| 5th row | Silver |
Common Values
| Value | Count | Frequency (%) |
| Black | 19594 | |
| Red | 8037 | |
| Yellow | 7429 | 12.8% |
| Silver | 6725 | 11.6% |
| Blue | 4580 | 7.9% |
| Multi | 4447 | 7.7% |
| Silver/Black | 1378 | 2.4% |
| White | 808 | 1.4% |
| (Missing) | 4853 | 8.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| black | 19594 | |
| red | 8037 | |
| yellow | 7429 | 14.0% |
| silver | 6725 | 12.7% |
| blue | 4580 | 8.6% |
| multi | 4447 | 8.4% |
| silver/black | 1378 | 2.6% |
| white | 808 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 52960 | |
| e | 28957 | |
| B | 25552 | |
| a | 20972 | 7.8% |
| c | 20972 | 7.8% |
| k | 20972 | 7.8% |
| i | 13358 | 5.0% |
| u | 9027 | 3.4% |
| v | 8103 | 3.0% |
| r | 8103 | 3.0% |
| Other values (11) | 59160 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 268136 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 52960 | |
| e | 28957 | |
| B | 25552 | |
| a | 20972 | 7.8% |
| c | 20972 | 7.8% |
| k | 20972 | 7.8% |
| i | 13358 | 5.0% |
| u | 9027 | 3.4% |
| v | 8103 | 3.0% |
| r | 8103 | 3.0% |
| Other values (11) | 59160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 268136 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 52960 | |
| e | 28957 | |
| B | 25552 | |
| a | 20972 | 7.8% |
| c | 20972 | 7.8% |
| k | 20972 | 7.8% |
| i | 13358 | 5.0% |
| u | 9027 | 3.4% |
| v | 8103 | 3.0% |
| r | 8103 | 3.0% |
| Other values (11) | 59160 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 268136 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 52960 | |
| e | 28957 | |
| B | 25552 | |
| a | 20972 | 7.8% |
| c | 20972 | 7.8% |
| k | 20972 | 7.8% |
| i | 13358 | 5.0% |
| u | 9027 | 3.4% |
| v | 8103 | 3.0% |
| r | 8103 | 3.0% |
| Other values (11) | 59160 |
Subcategory
Categorical
HIGH CORRELATION 
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
| Road Bikes | |
|---|---|
| Mountain Bikes | |
| Road Frames | |
| Mountain Frames | |
| Touring Bikes | |
| Other values (28) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 10.056991 |
| Min length | 4 |
Characters and Unicode
| Total characters | 581807 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jerseys |
|---|---|
| 2nd row | Mountain Bikes |
| 3rd row | Mountain Bikes |
| 4th row | Jerseys |
| 5th row | Mountain Frames |
Common Values
| Value | Count | Frequency (%) |
| Road Bikes | 12559 | |
| Mountain Bikes | 7169 | |
| Road Frames | 4608 | 8.0% |
| Mountain Frames | 4224 | 7.3% |
| Touring Bikes | 3933 | 6.8% |
| Jerseys | 3667 | 6.3% |
| Helmets | 2640 | 4.6% |
| Gloves | 2105 | 3.6% |
| Wheels | 1899 | 3.3% |
| Shorts | 1493 | 2.6% |
| Other values (23) | 13554 |
Length
| Value | Count | Frequency (%) |
| bikes | 23661 | |
| road | 17167 | |
| mountain | 11393 | |
| frames | 10092 | |
| touring | 5193 | 5.5% |
| jerseys | 3667 | 3.9% |
| helmets | 2640 | 2.8% |
| gloves | 2105 | 2.2% |
| wheels | 1899 | 2.0% |
| shorts | 1493 | 1.6% |
| Other values (28) | 14442 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 63503 | 10.9% |
| e | 61171 | 10.5% |
| a | 49047 | 8.4% |
| i | 43423 | 7.5% |
| o | 40713 | 7.0% |
| 35901 | 6.2% | |
| n | 31255 | 5.4% |
| k | 27089 | 4.7% |
| B | 26196 | 4.5% |
| r | 25400 | 4.4% |
| Other values (27) | 178109 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 581807 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 63503 | 10.9% |
| e | 61171 | 10.5% |
| a | 49047 | 8.4% |
| i | 43423 | 7.5% |
| o | 40713 | 7.0% |
| 35901 | 6.2% | |
| n | 31255 | 5.4% |
| k | 27089 | 4.7% |
| B | 26196 | 4.5% |
| r | 25400 | 4.4% |
| Other values (27) | 178109 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 581807 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 63503 | 10.9% |
| e | 61171 | 10.5% |
| a | 49047 | 8.4% |
| i | 43423 | 7.5% |
| o | 40713 | 7.0% |
| 35901 | 6.2% | |
| n | 31255 | 5.4% |
| k | 27089 | 4.7% |
| B | 26196 | 4.5% |
| r | 25400 | 4.4% |
| Other values (27) | 178109 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 581807 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 63503 | 10.9% |
| e | 61171 | 10.5% |
| a | 49047 | 8.4% |
| i | 43423 | 7.5% |
| o | 40713 | 7.0% |
| 35901 | 6.2% | |
| n | 31255 | 5.4% |
| k | 27089 | 4.7% |
| B | 26196 | 4.5% |
| r | 25400 | 4.4% |
| Other values (27) | 178109 |
Category
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
| Bikes | |
|---|---|
| Components | |
| Clothing | |
| Accessories |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 7.6323832 |
| Min length | 5 |
Characters and Unicode
| Total characters | 441541 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Clothing |
|---|---|
| 2nd row | Bikes |
| 3rd row | Bikes |
| 4th row | Clothing |
| 5th row | Components |
Common Values
| Value | Count | Frequency (%) |
| Bikes | 23661 | |
| Components | 17619 | |
| Clothing | 11745 | |
| Accessories | 4826 | 8.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bikes | 23661 | |
| components | 17619 | |
| clothing | 11745 | |
| accessories | 4826 | 8.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 55758 | |
| o | 51809 | |
| e | 50932 | |
| n | 46983 | |
| i | 40232 | |
| C | 29364 | |
| t | 29364 | |
| B | 23661 | 5.4% |
| k | 23661 | 5.4% |
| p | 17619 | 4.0% |
| Other values (7) | 72158 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 441541 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 55758 | |
| o | 51809 | |
| e | 50932 | |
| n | 46983 | |
| i | 40232 | |
| C | 29364 | |
| t | 29364 | |
| B | 23661 | 5.4% |
| k | 23661 | 5.4% |
| p | 17619 | 4.0% |
| Other values (7) | 72158 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 441541 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 55758 | |
| o | 51809 | |
| e | 50932 | |
| n | 46983 | |
| i | 40232 | |
| C | 29364 | |
| t | 29364 | |
| B | 23661 | 5.4% |
| k | 23661 | 5.4% |
| p | 17619 | 4.0% |
| Other values (7) | 72158 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 441541 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 55758 | |
| o | 51809 | |
| e | 50932 | |
| n | 46983 | |
| i | 40232 | |
| C | 29364 | |
| t | 29364 | |
| B | 23661 | 5.4% |
| k | 23661 | 5.4% |
| p | 17619 | 4.0% |
| Other values (7) | 72158 |
Profit
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1545 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.727361 |
| Minimum | -16444.39 |
|---|---|
| Maximum | 1278.36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 20599 |
| Negative (%) | 35.6% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | -16444.39 |
|---|---|
| 5-th percentile | -169.17 |
| Q1 | -18.36 |
| median | 13.84 |
| Q3 | 58.56 |
| 95-th percentile | 296.25 |
| Maximum | 1278.36 |
| Range | 17722.75 |
| Interquartile range (IQR) | 76.92 |
Descriptive statistics
| Standard deviation | 391.19874 |
|---|---|
| Coefficient of variation (CV) | 28.497738 |
| Kurtosis | 533.66001 |
| Mean | 13.727361 |
| Median Absolute Deviation (MAD) | 38.17 |
| Skewness | -18.22807 |
| Sum | 794141.57 |
| Variance | 153036.46 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.31 | 851 | 1.5% |
| -33.83 | 665 | 1.1% |
| 12.63 | 655 | 1.1% |
| -16.92 | 639 | 1.1% |
| -50.75 | 596 | 1.0% |
| -16.03 | 431 | 0.7% |
| -51.5 | 411 | 0.7% |
| -67.67 | 369 | 0.6% |
| -103 | 342 | 0.6% |
| 18.94 | 340 | 0.6% |
| Other values (1535) | 52552 |
| Value | Count | Frequency (%) |
| -16444.39 | 2 | < 0.1% |
| -15229.24 | 1 | < 0.1% |
| -14509.76 | 5 | |
| -12790.08 | 2 | < 0.1% |
| -11597.79 | 1 | < 0.1% |
| -11421.93 | 3 | |
| -11094.47 | 1 | < 0.1% |
| -10543.44 | 1 | < 0.1% |
| -9489.1 | 1 | < 0.1% |
| -9135.77 | 6 |
| Value | Count | Frequency (%) |
| 1278.36 | 4 | < 0.1% |
| 1268.96 | 4 | < 0.1% |
| 1263.7 | 7 | |
| 1250.09 | 8 | |
| 1249.94 | 7 | |
| 1236.5 | 9 | |
| 1157.38 | 2 | < 0.1% |
| 1150.52 | 3 | < 0.1% |
| 1142.06 | 11 | |
| 1137.33 | 12 |
Profit_Margin
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 1219 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5.8897676 |
| Minimum | -22395.941 |
|---|---|
| Maximum | 40.438596 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 20599 |
| Negative (%) | 35.6% |
| Memory size | 452.1 KiB |
Quantile statistics
| Minimum | -22395.941 |
|---|---|
| 5-th percentile | -28.348256 |
| Q1 | -3.5989313 |
| median | 7.6467229 |
| Q3 | 25.998079 |
| 95-th percentile | 37.65976 |
| Maximum | 40.438596 |
| Range | 22436.38 |
| Interquartile range (IQR) | 29.597011 |
Descriptive statistics
| Standard deviation | 555.18983 |
|---|---|
| Coefficient of variation (CV) | -94.263454 |
| Kurtosis | 1598.7284 |
| Mean | -5.8897676 |
| Median Absolute Deviation (MAD) | 11.247623 |
| Skewness | -39.796014 |
| Sum | -340728.94 |
| Variance | 308235.75 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -3.600899693 | 809 | 1.4% |
| 1.504315072 | 791 | 1.4% |
| -3.60029082 | 753 | 1.3% |
| 10.05726091 | 750 | 1.3% |
| -3.600544924 | 665 | 1.1% |
| 1.505507081 | 655 | 1.1% |
| -3.60160923 | 639 | 1.1% |
| -1.133986442 | 601 | 1.0% |
| -0.8979442242 | 563 | 1.0% |
| -6.067322138 | 549 | 0.9% |
| Other values (1209) | 51076 |
| Value | Count | Frequency (%) |
| -22395.94118 | 35 | |
| -7378.928571 | 2 | < 0.1% |
| -2627.59292 | 3 | < 0.1% |
| -2149.594074 | 5 | < 0.1% |
| -2149.593464 | 2 | < 0.1% |
| -2149.593277 | 2 | < 0.1% |
| -2149.592941 | 6 | < 0.1% |
| -2149.592157 | 10 | < 0.1% |
| -724.8952381 | 1 | < 0.1% |
| -648 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.43859649 | 49 | |
| 40.43255737 | 107 | |
| 40.43019883 | 17 | < 0.1% |
| 40.42842992 | 94 | |
| 40.4270541 | 5 | < 0.1% |
| 40.42606516 | 4 | < 0.1% |
| 40.42595344 | 54 | |
| 40.42430246 | 23 | < 0.1% |
| 40.42105263 | 20 | < 0.1% |
| 40.41666667 | 9 | < 0.1% |
trimestre
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 452.1 KiB |
| Category | Color | Continent | Cost | Country | EmployeeKey | ProductKey | Profit | Profit_Margin | Quantity | ResellerKey | Sales | SalesTerritoryKey | Subcategory | Unit Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 0.438 | 0.038 | -0.276 | 0.041 | 0.008 | 0.094 | 0.236 | 0.142 | -0.106 | 0.013 | -0.269 | -0.000 | 1.000 | -0.233 |
| Color | 0.438 | 1.000 | 0.175 | 0.102 | 0.120 | 0.041 | 0.159 | -0.252 | -0.277 | -0.043 | -0.001 | 0.073 | 0.032 | 0.787 | 0.101 |
| Continent | 0.038 | 0.175 | 1.000 | 0.024 | 1.000 | -0.319 | -0.072 | 0.004 | -0.023 | -0.065 | -0.036 | 0.022 | -0.457 | 0.236 | 0.048 |
| Cost | -0.276 | 0.102 | 0.024 | 1.000 | 0.016 | -0.021 | -0.019 | -0.108 | -0.541 | 0.160 | -0.006 | 0.991 | -0.040 | 0.126 | 0.912 |
| Country | 0.041 | 0.120 | 1.000 | 0.016 | 1.000 | -0.618 | -0.092 | 0.030 | -0.006 | -0.027 | -0.021 | 0.034 | -0.786 | 0.162 | 0.043 |
| EmployeeKey | 0.008 | 0.041 | -0.319 | -0.021 | -0.618 | 1.000 | 0.146 | -0.044 | -0.004 | 0.018 | 0.039 | -0.023 | 0.500 | 0.138 | -0.026 |
| ProductKey | 0.094 | 0.159 | -0.072 | -0.019 | -0.092 | 0.146 | 1.000 | -0.069 | 0.067 | -0.040 | 0.023 | -0.009 | 0.094 | 0.747 | 0.004 |
| Profit | 0.236 | -0.252 | 0.004 | -0.108 | 0.030 | -0.044 | -0.069 | 1.000 | 0.700 | 0.134 | 0.030 | -0.040 | -0.050 | 0.079 | -0.090 |
| Profit_Margin | 0.142 | -0.277 | -0.023 | -0.541 | -0.006 | -0.004 | 0.067 | 0.700 | 1.000 | 0.100 | 0.015 | -0.465 | -0.003 | 0.038 | -0.484 |
| Quantity | -0.106 | -0.043 | -0.065 | 0.160 | -0.027 | 0.018 | -0.040 | 0.134 | 0.100 | 1.000 | -0.022 | 0.177 | 0.020 | 0.116 | -0.207 |
| ResellerKey | 0.013 | -0.001 | -0.036 | -0.006 | -0.021 | 0.039 | 0.023 | 0.030 | 0.015 | -0.022 | 1.000 | -0.007 | -0.001 | 0.059 | 0.006 |
| Sales | -0.269 | 0.073 | 0.022 | 0.991 | 0.034 | -0.023 | -0.009 | -0.040 | -0.465 | 0.177 | -0.007 | 1.000 | -0.042 | 0.151 | 0.908 |
| SalesTerritoryKey | -0.000 | 0.032 | -0.457 | -0.040 | -0.786 | 0.500 | 0.094 | -0.050 | -0.003 | 0.020 | -0.001 | -0.042 | 1.000 | 0.133 | -0.048 |
| Subcategory | 1.000 | 0.787 | 0.236 | 0.126 | 0.162 | 0.138 | 0.747 | 0.079 | 0.038 | 0.116 | 0.059 | 0.151 | 0.133 | 1.000 | 0.344 |
| Unit Price | -0.233 | 0.101 | 0.048 | 0.912 | 0.043 | -0.026 | 0.004 | -0.090 | -0.484 | -0.207 | 0.006 | 0.908 | -0.048 | 0.344 | 1.000 |
| SalesOrderNumber | OrderDate | ProductKey | ResellerKey | EmployeeKey | SalesTerritoryKey | Quantity | Unit Price | Sales | Cost | Country | Continent | Product | Color | Subcategory | Category | Profit | Profit_Margin | trimestre | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SO43897 | 2017-08-25 | 235 | 312 | 282 | 4 | 2 | 28.84 | 57.68 | 63.45 | United States | North America | Long-Sleeve Logo Jersey, XL | Multi | Jerseys | Clothing | -5.77 | -10.003467 | 2017-08-25 00:00 |
| 1 | SO43897 | 2017-08-25 | 351 | 312 | 282 | 4 | 2 | 2024.99 | 4049.98 | 3796.19 | United States | North America | Mountain-100 Black, 48 | Black | Mountain Bikes | Bikes | 253.79 | 6.266451 | 2017-08-25 00:00 |
| 2 | SO43897 | 2017-08-25 | 348 | 312 | 282 | 4 | 2 | 2024.99 | 4049.98 | 3796.19 | United States | North America | Mountain-100 Black, 38 | Black | Mountain Bikes | Bikes | 253.79 | 6.266451 | 2017-08-25 00:00 |
| 3 | SO43897 | 2017-08-25 | 232 | 312 | 282 | 4 | 2 | 28.84 | 57.68 | 63.45 | United States | North America | Long-Sleeve Logo Jersey, L | Multi | Jerseys | Clothing | -5.77 | -10.003467 | 2017-08-25 00:00 |
| 4 | SO44544 | 2017-11-18 | 292 | 312 | 282 | 4 | 2 | 818.70 | 1637.40 | 1413.62 | United States | North America | HL Mountain Frame - Silver, 48 | Silver | Mountain Frames | Components | 223.78 | 13.666789 | 2017-11-18 00:00 |
| 5 | SO44544 | 2017-11-18 | 220 | 312 | 282 | 4 | 2 | 20.19 | 40.38 | 24.06 | United States | North America | Sport-100 Helmet, Blue | Blue | Helmets | Accessories | 16.32 | 40.416048 | 2017-11-18 00:00 |
| 6 | SO44544 | 2017-11-18 | 351 | 312 | 282 | 4 | 2 | 2024.99 | 4049.98 | 3796.19 | United States | North America | Mountain-100 Black, 48 | Black | Mountain Bikes | Bikes | 253.79 | 6.266451 | 2017-11-18 00:00 |
| 7 | SO44544 | 2017-11-18 | 349 | 312 | 282 | 4 | 2 | 2024.99 | 4049.98 | 3796.19 | United States | North America | Mountain-100 Black, 42 | Black | Mountain Bikes | Bikes | 253.79 | 6.266451 | 2017-11-18 00:00 |
| 8 | SO44544 | 2017-11-18 | 344 | 312 | 282 | 4 | 2 | 2039.99 | 4079.98 | 3824.31 | United States | North America | Mountain-100 Silver, 38 | Silver | Mountain Bikes | Bikes | 255.67 | 6.266452 | 2017-11-18 00:00 |
| 9 | SO45321 | 2018-02-18 | 346 | 312 | 282 | 4 | 2 | 2039.99 | 4079.98 | 3824.31 | United States | North America | Mountain-100 Silver, 44 | Silver | Mountain Bikes | Bikes | 255.67 | 6.266452 | 2018-02-18 00:00 |
| SalesOrderNumber | OrderDate | ProductKey | ResellerKey | EmployeeKey | SalesTerritoryKey | Quantity | Unit Price | Sales | Cost | Country | Continent | Product | Color | Subcategory | Category | Profit | Profit_Margin | trimestre | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57841 | SO67349 | 2020-04-30 | 471 | 81 | 285 | 5 | 20 | 34.93 | 698.60 | 474.98 | United States | North America | Classic Vest, S | Blue | Vests | Clothing | 223.62 | 32.009734 | 2020-04-30 00:00 |
| 57842 | SO69416 | 2020-05-06 | 482 | 377 | 283 | 3 | 20 | 4.94 | 98.80 | 67.25 | United States | North America | Racing Socks, L | White | Socks | Clothing | 31.55 | 31.933198 | 2020-05-06 00:00 |
| 57843 | SO69424 | 2020-05-07 | 482 | 310 | 281 | 3 | 28 | 4.50 | 126.00 | 94.14 | United States | North America | Racing Socks, L | White | Socks | Clothing | 31.86 | 25.285714 | 2020-05-07 00:00 |
| 57844 | SO69437 | 2020-05-09 | 471 | 175 | 292 | 7 | 24 | 34.93 | 838.32 | 569.98 | France | Europe | Classic Vest, S | Blue | Vests | Clothing | 268.34 | 32.009257 | 2020-05-09 00:00 |
| 57845 | SO69471 | 2020-05-14 | 476 | 697 | 282 | 1 | 20 | 38.49 | 769.80 | 523.53 | United States | North America | Women's Mountain Shorts, L | Black | Shorts | Clothing | 246.27 | 31.991426 | 2020-05-14 00:00 |
| 57846 | SO69476 | 2020-05-15 | 476 | 667 | 283 | 2 | 21 | 38.49 | 808.29 | 549.70 | United States | North America | Women's Mountain Shorts, L | Black | Shorts | Clothing | 258.59 | 31.992231 | 2020-05-15 00:00 |
| 57847 | SO69476 | 2020-05-15 | 474 | 667 | 283 | 2 | 19 | 38.49 | 731.31 | 497.35 | United States | North America | Women's Mountain Shorts, S | Black | Shorts | Clothing | 233.96 | 31.991905 | 2020-05-15 00:00 |
| 57848 | SO69493 | 2020-05-18 | 482 | 89 | 283 | 2 | 20 | 4.94 | 98.80 | 67.25 | United States | North America | Racing Socks, L | White | Socks | Clothing | 31.55 | 31.933198 | 2020-05-18 00:00 |
| 57849 | SO69503 | 2020-05-20 | 482 | 79 | 282 | 3 | 23 | 4.94 | 113.62 | 77.33 | United States | North America | Racing Socks, L | White | Socks | Clothing | 36.29 | 31.939799 | 2020-05-20 00:00 |
| 57850 | SO69561 | 2020-05-31 | 474 | 546 | 282 | 3 | 26 | 35.00 | 910.00 | 680.58 | United States | North America | Women's Mountain Shorts, S | Black | Shorts | Clothing | 229.42 | 25.210989 | 2020-05-31 00:00 |